Food Inspection Report

Dataset statistics

Number of variables	17
Number of observations	267751
Missing cells	84142
Missing cells (%)	1.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.7 MiB
Average record size in memory	136.0 B

Variable types

Numeric	5
Text	8
Categorical	3
DateTime	1

Alerts

`State` is highly imbalanced (> 99.9%)	Imbalance
`Facility Type` has 5119 (1.9%) missing values	Missing
`Violations` has 73407 (27.4%) missing values	Missing
`Zip` is highly skewed (γ1 = -111.2126359)	Skewed
`Inspection ID` has unique values	Unique

Reproduction

Analysis started	2024-02-22 02:32:02.122920
Analysis finished	2024-02-22 02:33:08.367401
Duration	1 minute and 6.24 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

Inspection ID
Real number (ℝ)

UNIQUE

Distinct	267751
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1730421.2

Minimum	44247
Maximum	2589714
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	44247
5-th percentile	327249.5
Q1	1307406.5
median	1950942
Q3	2357112.5
95-th percentile	2575903.5
Maximum	2589714
Range	2545467
Interquartile range (IQR)	1049706

Descriptive statistics

Standard deviation	719559.68
Coefficient of variation (CV)	0.4158292
Kurtosis	-0.65172413
Mean	1730421.2
Median Absolute Deviation (MAD)	547188
Skewness	-0.62851911
Sum	4.6332202 × 10¹¹
Variance	5.1776613 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2589679	1	< 0.1%
1522360	1	< 0.1%
1441701	1	< 0.1%
1527330	1	< 0.1%
1527259	1	< 0.1%
1516188	1	< 0.1%
1523155	1	< 0.1%
1385918	1	< 0.1%
1527795	1	< 0.1%
1386059	1	< 0.1%
Other values (267741)	267741	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44247	1	< 0.1%
44248	1	< 0.1%
44249	1	< 0.1%
44250	1	< 0.1%
44251	1	< 0.1%
44252	1	< 0.1%
44253	1	< 0.1%
44254	1	< 0.1%
44255	1	< 0.1%
44256	1	< 0.1%

Value	Count	Frequency (%)
2589714	1	< 0.1%
2589700	1	< 0.1%
2589699	1	< 0.1%
2589698	1	< 0.1%
2589695	1	< 0.1%
2589691	1	< 0.1%
2589684	1	< 0.1%
2589683	1	< 0.1%
2589682	1	< 0.1%
2589681	1	< 0.1%

DBA Name
Text

Distinct	32180
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

Length

Max length	79
Median length	49
Mean length	18.732057
Min length	1

Characters and Unicode

Total characters	5015527
Distinct characters	83
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5943 ?
Unique (%)	2.2%

Sample

1st row	HOLY SMOQUES BBQ
2nd row	SMALL CHEVAL
3rd row	BARTOLI'S PIZZERIA
4th row	SEASHELL
5th row	J & J FISH & CHICKEN

Value	Count	Frequency (%)
inc	27088	3.3%
	26509	3.3%
restaurant	15492	1.9%
food	11428	1.4%
the	10948	1.3%
cafe	8798	1.1%
chicago	7635	0.9%
grill	7329	0.9%
and	6539	0.8%
pizza	6471	0.8%
Other values (18949)	685836	84.2%

Most occurring characters

Value	Count	Frequency (%)
	551655	11.0%
A	412346	8.2%
E	408546	8.1%
R	299532	6.0%
I	289512	5.8%
O	286584	5.7%
N	279206	5.6%
S	275782	5.5%
T	247632	4.9%
C	232708	4.6%
Other values (73)	1732024	34.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4054538	80.8%
Space Separator	551655	11.0%
Lowercase Letter	195373	3.9%
Other Punctuation	126789	2.5%
Decimal Number	74810	1.5%
Dash Punctuation	9060	0.2%
Open Punctuation	1465	< 0.1%
Close Punctuation	1465	< 0.1%
Math Symbol	337	< 0.1%
Connector Punctuation	18	< 0.1%
Other values (2)	17	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	412346	10.2%
E	408546	10.1%
R	299532	7.4%
I	289512	7.1%
O	286584	7.1%
N	279206	6.9%
S	275782	6.8%
T	247632	6.1%
C	232708	5.7%
L	214089	5.3%
Other values (16)	1108601	27.3%

Lowercase Letter

Value	Count	Frequency (%)
e	23866	12.2%
a	21138	10.8%
o	16442	8.4%
n	15977	8.2%
r	15305	7.8%
i	13724	7.0%
l	12251	6.3%
t	12146	6.2%
s	10363	5.3%
c	8083	4.1%
Other values (16)	46078	23.6%

Other Punctuation

Value	Count	Frequency (%)
'	41729	32.9%
.	24413	19.3%
&	21626	17.1%
,	17302	13.6%
#	15178	12.0%
/	5054	4.0%
@	1047	0.8%
!	311	0.2%
:	51	< 0.1%
?	50	< 0.1%
Other values (3)	28	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	11341	15.2%
1	11064	14.8%
3	9559	12.8%
7	7539	10.1%
5	7275	9.7%
0	6946	9.3%
4	6546	8.8%
8	5227	7.0%
6	5015	6.7%
9	4298	5.7%

Space Separator

Value	Count	Frequency (%)
	551655	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9060	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1465	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1465	100.0%

Math Symbol

Value	Count	Frequency (%)
+	337	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	18	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	11	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4249911	84.7%
Common	765616	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	412346	9.7%
E	408546	9.6%
R	299532	7.0%
I	289512	6.8%
O	286584	6.7%
N	279206	6.6%
S	275782	6.5%
T	247632	5.8%
C	232708	5.5%
L	214089	5.0%
Other values (42)	1303974	30.7%

Common

Value	Count	Frequency (%)
	551655	72.1%
'	41729	5.5%
.	24413	3.2%
&	21626	2.8%
,	17302	2.3%
#	15178	2.0%
2	11341	1.5%
1	11064	1.4%
3	9559	1.2%
-	9060	1.2%
Other values (21)	52689	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5015527	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	551655	11.0%
A	412346	8.2%
E	408546	8.1%
R	299532	6.0%
I	289512	5.8%
O	286584	5.7%
N	279206	5.6%
S	275782	5.5%
T	247632	4.9%
C	232708	4.6%
Other values (73)	1732024	34.5%

AKA Name
Text

Distinct	30627
Distinct (%)	11.5%
Missing	2471
Missing (%)	0.9%
Memory size	2.0 MiB

Length

Max length	79
Median length	49
Mean length	17.914931
Min length	2

Characters and Unicode

Total characters	4752473
Distinct characters	87
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5783 ?
Unique (%)	2.2%

Sample

1st row	HOLY SMOQUES BBQ
2nd row	SMALL CHEVAL
3rd row	BARTOLI'S PIZZERIA
4th row	SEASHELL
5th row	J & J FISH & CHICKEN

Value	Count	Frequency (%)
	24623	3.2%
restaurant	14781	1.9%
inc	12551	1.6%
food	11144	1.4%
the	10549	1.4%
cafe	9476	1.2%
grill	7462	1.0%
school	6925	0.9%
pizza	6614	0.9%
la	6337	0.8%
Other values (18276)	658436	85.6%

Most occurring characters

Value	Count	Frequency (%)
	509713	10.7%
A	402141	8.5%
E	397977	8.4%
R	288312	6.1%
O	274447	5.8%
S	268924	5.7%
I	264031	5.6%
N	256321	5.4%
T	239553	5.0%
C	206810	4.4%
Other values (77)	1644244	34.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3884996	81.7%
Space Separator	509713	10.7%
Lowercase Letter	182405	3.8%
Other Punctuation	104726	2.2%
Decimal Number	52447	1.1%
Dash Punctuation	8805	0.2%
Open Punctuation	4485	0.1%
Close Punctuation	4463	0.1%
Math Symbol	371	< 0.1%
Connector Punctuation	31	< 0.1%
Other values (3)	31	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	22955	12.6%
a	19535	10.7%
o	15200	8.3%
n	14434	7.9%
r	14092	7.7%
i	12857	7.0%
l	12102	6.6%
t	11108	6.1%
s	9066	5.0%
c	7329	4.0%
Other values (17)	43727	24.0%

Uppercase Letter

Value	Count	Frequency (%)
A	402141	10.4%
E	397977	10.2%
R	288312	7.4%
O	274447	7.1%
S	268924	6.9%
I	264031	6.8%
N	256321	6.6%
T	239553	6.2%
C	206810	5.3%
L	201386	5.2%
Other values (16)	1085094	27.9%

Other Punctuation

Value	Count	Frequency (%)
'	42791	40.9%
&	20852	19.9%
.	14745	14.1%
#	9164	8.8%
/	8037	7.7%
,	7986	7.6%
@	738	0.7%
!	283	0.3%
?	47	< 0.1%
:	33	< 0.1%
Other values (3)	50	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	8996	17.2%
2	8034	15.3%
3	6972	13.3%
7	5640	10.8%
5	4883	9.3%
4	4725	9.0%
0	4486	8.6%
6	3163	6.0%
8	2990	5.7%
9	2558	4.9%

Open Punctuation

Value	Count	Frequency (%)
(	4480	99.9%
[	5	0.1%

Close Punctuation

Value	Count	Frequency (%)
)	4458	99.9%
]	5	0.1%

Space Separator

Value	Count	Frequency (%)
	509713	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8805	100.0%

Math Symbol

Value	Count	Frequency (%)
+	371	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	31	100.0%

Other Number

Value	Count	Frequency (%)
½	24	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	6	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4067401	85.6%
Common	685072	14.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	402141	9.9%
E	397977	9.8%
R	288312	7.1%
O	274447	6.7%
S	268924	6.6%
I	264031	6.5%
N	256321	6.3%
T	239553	5.9%
C	206810	5.1%
L	201386	5.0%
Other values (43)	1267499	31.2%

Common

Value	Count	Frequency (%)
	509713	74.4%
'	42791	6.2%
&	20852	3.0%
.	14745	2.2%
#	9164	1.3%
1	8996	1.3%
-	8805	1.3%
/	8037	1.2%
2	8034	1.2%
,	7986	1.2%
Other values (24)	45949	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4752401	> 99.9%
None	72	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	509713	10.7%
A	402141	8.5%
E	397977	8.4%
R	288312	6.1%
O	274447	5.8%
S	268924	5.7%
I	264031	5.6%
N	256321	5.4%
T	239553	5.0%
C	206810	4.4%
Other values (74)	1644172	34.6%

None

Value	Count	Frequency (%)
½	24	33.3%
¿	24	33.3%
ï	24	33.3%

License #
Real number (ℝ)

Distinct	44526
Distinct (%)	16.6%
Missing	18
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1721965

Minimum	0
Maximum	9999999
Zeros	692
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	0
5-th percentile	17602
Q1	1336926
median	2048786
Q3	2369214
95-th percentile	2766692
Maximum	9999999
Range	9999999
Interquartile range (IQR)	1032288

Descriptive statistics

Standard deviation	927107.12
Coefficient of variation (CV)	0.53840066
Kurtosis	-0.4260346
Mean	1721965
Median Absolute Deviation (MAD)	420481
Skewness	-0.89674014
Sum	4.6102686 × 10¹¹
Variance	8.595276 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	692	0.3%
1354323	198	0.1%
14616	181	0.1%
1574001	86	< 0.1%
60184	64	< 0.1%
2083833	62	< 0.1%
1974745	59	< 0.1%
1142451	59	< 0.1%
1884255	55	< 0.1%
1596210	54	< 0.1%
Other values (44516)	266223	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	692	0.3%
1	1	< 0.1%
2	17	< 0.1%
9	15	< 0.1%
40	21	< 0.1%
43	1	< 0.1%
62	18	< 0.1%
85	5	< 0.1%
99	13	< 0.1%
104	1	< 0.1%

Value	Count	Frequency (%)
9999999	1	< 0.1%
8700606	3	< 0.1%
5852857	1	< 0.1%
4076132	2	< 0.1%
4075924	2	< 0.1%
4075688	1	< 0.1%
4075628	2	< 0.1%
4075597	1	< 0.1%
4075446	1	< 0.1%
4075357	2	< 0.1%

Facility Type
Text

MISSING

Distinct	513
Distinct (%)	0.2%
Missing	5119
Missing (%)	1.9%
Memory size	2.0 MiB

Length

Max length	47
Median length	10
Mean length	11.105041
Min length	3

Characters and Unicode

Total characters	2916539
Distinct characters	69
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	73 ?
Unique (%)	< 0.1%

Sample

1st row	Restaurant
2nd row	Restaurant
3rd row	Restaurant
4th row	Restaurant
5th row	Restaurant

Value	Count	Frequency (%)
restaurant	179982	50.6%
store	33670	9.5%
grocery	33531	9.4%
school	17352	4.9%
daycare	7841	2.2%
2	7030	2.0%
years	7027	2.0%
facility	5875	1.7%
services	5811	1.6%
children's	5727	1.6%
Other values (445)	52142	14.6%

Most occurring characters

Value	Count	Frequency (%)
t	403490	13.8%
a	403275	13.8%
r	328247	11.3%
e	308801	10.6%
s	203023	7.0%
n	201445	6.9%
R	185107	6.3%
u	181398	6.2%
o	118560	4.1%
	93370	3.2%
Other values (59)	489823	16.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2410697	82.7%
Uppercase Letter	381158	13.1%
Space Separator	93370	3.2%
Decimal Number	13505	0.5%
Other Punctuation	6629	0.2%
Close Punctuation	3877	0.1%
Open Punctuation	3877	0.1%
Dash Punctuation	3423	0.1%
Connector Punctuation	3	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	185107	48.6%
S	60776	15.9%
G	35423	9.3%
C	13101	3.4%
D	10425	2.7%
F	8713	2.3%
A	8254	2.2%
Y	8166	2.1%
T	7034	1.8%
E	5932	1.6%
Other values (16)	38227	10.0%

Lowercase Letter

Value	Count	Frequency (%)
t	403490	16.7%
a	403275	16.7%
r	328247	13.6%
e	308801	12.8%
s	203023	8.4%
n	201445	8.4%
u	181398	7.5%
o	118560	4.9%
c	70776	2.9%
y	50887	2.1%
Other values (14)	140795	5.8%

Decimal Number

Value	Count	Frequency (%)
2	7156	53.0%
6	3852	28.5%
1	841	6.2%
5	728	5.4%
8	703	5.2%
0	109	0.8%
3	98	0.7%
4	16	0.1%
7	2	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
'	5816	87.7%
/	743	11.2%
&	42	0.6%
.	22	0.3%
,	6	0.1%

Space Separator

Value	Count	Frequency (%)
	93370	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3877	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3877	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3423	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2791855	95.7%
Common	124684	4.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	403490	14.5%
a	403275	14.4%
r	328247	11.8%
e	308801	11.1%
s	203023	7.3%
n	201445	7.2%
R	185107	6.6%
u	181398	6.5%
o	118560	4.2%
c	70776	2.5%
Other values (40)	387733	13.9%

Common

Value	Count	Frequency (%)
	93370	74.9%
2	7156	5.7%
'	5816	4.7%
)	3877	3.1%
(	3877	3.1%
6	3852	3.1%
-	3423	2.7%
1	841	0.7%
/	743	0.6%
5	728	0.6%
Other values (9)	1001	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2916539	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	403490	13.8%
a	403275	13.8%
r	328247	11.3%
e	308801	10.6%
s	203023	7.0%
n	201445	6.9%
R	185107	6.3%
u	181398	6.2%
o	118560	4.1%
	93370	3.2%
Other values (59)	489823	16.8%

Risk
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	82
Missing (%)	< 0.1%
Memory size	2.0 MiB

Risk 1 (High)	196229
Risk 2 (Medium)	49583
Risk 3 (Low)	21801
All	56

Length

Max length	15
Median length	13
Mean length	13.28694
Min length	3

Characters and Unicode

Total characters	3556502
Distinct characters	23
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Risk 1 (High)
2nd row	Risk 1 (High)
3rd row	Risk 1 (High)
4th row	Risk 2 (Medium)
5th row	Risk 1 (High)

Common Values

Value	Count	Frequency (%)
Risk 1 (High)	196229	73.3%
Risk 2 (Medium)	49583	18.5%
Risk 3 (Low)	21801	8.1%
All	56	< 0.1%
(Missing)	82	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
risk	267613	33.3%
1	196229	24.4%
high	196229	24.4%
2	49583	6.2%
medium	49583	6.2%
3	21801	2.7%
low	21801	2.7%
all	56	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	535226	15.0%
i	513425	14.4%
R	267613	7.5%
s	267613	7.5%
k	267613	7.5%
(	267613	7.5%
)	267613	7.5%
1	196229	5.5%
H	196229	5.5%
g	196229	5.5%
Other values (13)	581099	16.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1683155	47.3%
Uppercase Letter	535282	15.1%
Space Separator	535226	15.0%
Open Punctuation	267613	7.5%
Close Punctuation	267613	7.5%
Decimal Number	267613	7.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	513425	30.5%
s	267613	15.9%
k	267613	15.9%
g	196229	11.7%
h	196229	11.7%
d	49583	2.9%
m	49583	2.9%
u	49583	2.9%
e	49583	2.9%
o	21801	1.3%
Other values (2)	21913	1.3%

Uppercase Letter

Value	Count	Frequency (%)
R	267613	50.0%
H	196229	36.7%
M	49583	9.3%
L	21801	4.1%
A	56	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	196229	73.3%
2	49583	18.5%
3	21801	8.1%

Space Separator

Value	Count	Frequency (%)
	535226	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	267613	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	267613	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2218437	62.4%
Common	1338065	37.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	513425	23.1%
R	267613	12.1%
s	267613	12.1%
k	267613	12.1%
H	196229	8.8%
g	196229	8.8%
h	196229	8.8%
d	49583	2.2%
m	49583	2.2%
u	49583	2.2%
Other values (7)	164737	7.4%

Common

Value	Count	Frequency (%)
	535226	40.0%
(	267613	20.0%
)	267613	20.0%
1	196229	14.7%
2	49583	3.7%
3	21801	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3556502	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	535226	15.0%
i	513425	14.4%
R	267613	7.5%
s	267613	7.5%
k	267613	7.5%
(	267613	7.5%
)	267613	7.5%
1	196229	5.5%
H	196229	5.5%
g	196229	5.5%
Other values (13)	581099	16.3%

Address
Text

Distinct	19645
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

Length

Max length	52
Median length	40
Mean length	18.610395
Min length	1

Characters and Unicode

Total characters	4982952
Distinct characters	72
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2050 ?
Unique (%)	0.8%

Sample

1st row	2524 S CALIFORNIA AVE
2nd row	1307-1309 E 53RD ST
3rd row	658 N ASHLAND AVE
4th row	3944 W ROOSEVELT RD
5th row	6814 S STONY ISLAND AVE

Value	Count	Frequency (%)
ave	123998	11.4%
w	106371	9.8%
st	97068	8.9%
n	80270	7.4%
s	59381	5.5%
e	21675	2.0%
rd	15973	1.5%
clark	9483	0.9%
western	6764	0.6%
halsted	6705	0.6%
Other values (8742)	557903	51.4%

Most occurring characters

Value	Count	Frequency (%)
	1086045	21.8%
E	303670	6.1%
A	288037	5.8%
S	245610	4.9%
N	209153	4.2%
T	205102	4.1%
1	201738	4.0%
0	163844	3.3%
R	159152	3.2%
W	155889	3.1%
Other values (62)	1964712	39.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2571750	51.6%
Decimal Number	1200025	24.1%
Space Separator	1086045	21.8%
Lowercase Letter	86734	1.7%
Dash Punctuation	26108	0.5%
Close Punctuation	5517	0.1%
Open Punctuation	5517	0.1%
Other Punctuation	1253	< 0.1%
Math Symbol	2	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	303670	11.8%
A	288037	11.2%
S	245610	9.6%
N	209153	8.1%
T	205102	8.0%
R	159152	6.2%
W	155889	6.1%
V	149526	5.8%
L	123780	4.8%
O	111597	4.3%
Other values (16)	620234	24.1%

Lowercase Letter

Value	Count	Frequency (%)
a	9763	11.3%
e	9147	10.5%
t	7894	9.1%
n	7573	8.7%
r	7298	8.4%
o	6604	7.6%
i	6348	7.3%
l	6148	7.1%
h	4226	4.9%
s	3553	4.1%
Other values (15)	18180	21.0%

Decimal Number

Value	Count	Frequency (%)
1	201738	16.8%
0	163844	13.7%
2	146311	12.2%
3	145319	12.1%
5	139641	11.6%
4	120776	10.1%
6	88387	7.4%
7	74438	6.2%
8	59820	5.0%
9	59751	5.0%

Other Punctuation

Value	Count	Frequency (%)
/	721	57.5%
.	369	29.4%
&	133	10.6%
'	27	2.2%
#	3	0.2%

Space Separator

Value	Count	Frequency (%)
	1086045	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	26108	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5517	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	5517	100.0%

Math Symbol

Value	Count	Frequency (%)
~	2	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2658484	53.4%
Common	2324468	46.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	303670	11.4%
A	288037	10.8%
S	245610	9.2%
N	209153	7.9%
T	205102	7.7%
R	159152	6.0%
W	155889	5.9%
V	149526	5.6%
L	123780	4.7%
O	111597	4.2%
Other values (41)	706968	26.6%

Common

Value	Count	Frequency (%)
	1086045	46.7%
1	201738	8.7%
0	163844	7.0%
2	146311	6.3%
3	145319	6.3%
5	139641	6.0%
4	120776	5.2%
6	88387	3.8%
7	74438	3.2%
8	59820	2.6%
Other values (11)	98149	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4982952	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1086045	21.8%
E	303670	6.1%
A	288037	5.8%
S	245610	4.9%
N	209153	4.2%
T	205102	4.1%
1	201738	4.0%
0	163844	3.3%
R	159152	3.2%
W	155889	3.1%
Other values (62)	1964712	39.4%

City
Text

Distinct	79
Distinct (%)	< 0.1%
Missing	161
Missing (%)	0.1%
Memory size	2.0 MiB

Length

Max length	20
Median length	7
Mean length	7.0028252
Min length	2

Characters and Unicode

Total characters	1873886
Distinct characters	44
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	34 ?
Unique (%)	< 0.1%

Sample

1st row	CHICAGO
2nd row	CHICAGO
3rd row	CHICAGO
4th row	CHICAGO
5th row	CHICAGO

Value	Count	Frequency (%)
chicago	267273	99.8%
cchicago	55	< 0.1%
schaumburg	28	< 0.1%
park	19	< 0.1%
evanston	18	< 0.1%
maywood	16	< 0.1%
grove	14	< 0.1%
niles	14	< 0.1%
elk	13	< 0.1%
village	13	< 0.1%
Other values (80)	219	0.1%

Most occurring characters

Value	Count	Frequency (%)
C	534183	28.5%
A	266974	14.2%
I	266937	14.2%
O	266936	14.2%
H	266898	14.2%
G	266872	14.2%
c	721	< 0.1%
o	581	< 0.1%
i	580	< 0.1%
a	580	< 0.1%
Other values (34)	2624	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1870168	99.8%
Lowercase Letter	3609	0.2%
Space Separator	92	< 0.1%
Decimal Number	12	< 0.1%
Other Punctuation	5	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	534183	28.6%
A	266974	14.3%
I	266937	14.3%
O	266936	14.3%
H	266898	14.3%
G	266872	14.3%
E	213	< 0.1%
L	146	< 0.1%
R	145	< 0.1%
S	122	< 0.1%
Other values (15)	742	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
c	721	20.0%
o	581	16.1%
i	580	16.1%
a	580	16.1%
g	579	16.0%
h	558	15.5%
d	2	0.1%
r	2	0.1%
e	1	< 0.1%
y	1	< 0.1%
Other values (4)	4	0.1%

Decimal Number

Value	Count	Frequency (%)
3	4	33.3%
1	4	33.3%
2	4	33.3%

Space Separator

Value	Count	Frequency (%)
	92	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1873777	> 99.9%
Common	109	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	534183	28.5%
A	266974	14.2%
I	266937	14.2%
O	266936	14.2%
H	266898	14.2%
G	266872	14.2%
c	721	< 0.1%
o	581	< 0.1%
i	580	< 0.1%
a	580	< 0.1%
Other values (29)	2515	0.1%

Common

Value	Count	Frequency (%)
	92	84.4%
.	5	4.6%
3	4	3.7%
1	4	3.7%
2	4	3.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1873886	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	534183	28.5%
A	266974	14.2%
I	266937	14.2%
O	266936	14.2%
H	266898	14.2%
G	266872	14.2%
c	721	< 0.1%
o	581	< 0.1%
i	580	< 0.1%
a	580	< 0.1%
Other values (34)	2624	0.1%

State
Categorical

IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	59
Missing (%)	< 0.1%
Memory size	2.0 MiB

IL	267681
IN	7
CA	2
WI	1
NY	1

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	535384
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	IL
2nd row	IL
3rd row	IL
4th row	IL
5th row	IL

Common Values

Value	Count	Frequency (%)
IL	267681	> 99.9%
IN	7	< 0.1%
CA	2	< 0.1%
WI	1	< 0.1%
NY	1	< 0.1%
(Missing)	59	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
il	267681	> 99.9%
in	7	< 0.1%
ca	2	< 0.1%
wi	1	< 0.1%
ny	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
I	267689	50.0%
L	267681	50.0%
N	8	< 0.1%
C	2	< 0.1%
A	2	< 0.1%
W	1	< 0.1%
Y	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	535384	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	267689	50.0%
L	267681	50.0%
N	8	< 0.1%
C	2	< 0.1%
A	2	< 0.1%
W	1	< 0.1%
Y	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	535384	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	267689	50.0%
L	267681	50.0%
N	8	< 0.1%
C	2	< 0.1%
A	2	< 0.1%
W	1	< 0.1%
Y	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	535384	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	267689	50.0%
L	267681	50.0%
N	8	< 0.1%
C	2	< 0.1%
A	2	< 0.1%
W	1	< 0.1%
Y	1	< 0.1%

Zip
Real number (ℝ)

SKEWED

Distinct	121
Distinct (%)	< 0.1%
Missing	49
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	60628.704

Minimum	10014
Maximum	90504
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	10014
5-th percentile	60605
Q1	60614
median	60625
Q3	60643
95-th percentile	60659
Maximum	90504
Range	80490
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	148.81933
Coefficient of variation (CV)	0.0024546019
Kurtosis	63980.958
Mean	60628.704
Median Absolute Deviation (MAD)	14
Skewness	-111.21264
Sum	1.6230425 × 10¹⁰
Variance	22147.193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60614	9863	3.7%
60647	9783	3.7%
60657	9077	3.4%
60618	8418	3.1%
60611	8352	3.1%
60622	8187	3.1%
60608	8126	3.0%
60625	7568	2.8%
60607	7351	2.7%
60640	7192	2.7%
Other values (111)	183785	68.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10014	1	< 0.1%
46319	1	< 0.1%
46394	1	< 0.1%
46410	5	< 0.1%
53061	1	< 0.1%
60007	13	< 0.1%
60015	2	< 0.1%
60018	4	< 0.1%
60022	1	< 0.1%
60035	3	< 0.1%

Value	Count	Frequency (%)
90504	1	< 0.1%
90067	1	< 0.1%
60827	220	0.1%
60805	4	< 0.1%
60804	9	< 0.1%
60803	3	< 0.1%
60714	7	< 0.1%
60707	1542	0.6%
60706	4	< 0.1%
60666	3336	1.2%

Inspection Date
Date

Distinct	3566
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

Minimum	2010-01-04 00:00:00
Maximum	2024-02-16 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Inspection Type
Text

Distinct	110
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	2.0 MiB

Length

Max length	41
Median length	7
Mean length	10.646088
Min length	3

Characters and Unicode

Total characters	2850490
Distinct characters	61
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	69 ?
Unique (%)	< 0.1%

Sample

1st row	License Re-Inspection
2nd row	Canvass
3rd row	Canvass Re-Inspection
4th row	Complaint
5th row	Canvass Re-Inspection

Value	Count	Frequency (%)
canvass	168648	49.3%
re-inspection	51856	15.1%
license	47253	13.8%
complaint	44315	12.9%
short	8426	2.5%
form	8426	2.5%
non-inspection	2830	0.8%
suspected	1190	0.3%
food	1190	0.3%
poisoning	1190	0.3%
Other values (122)	7061	2.1%

Most occurring characters

Value	Count	Frequency (%)
s	445272	15.6%
a	384938	13.5%
n	378909	13.3%
C	214083	7.5%
e	208370	7.3%
v	169376	5.9%
i	152015	5.3%
o	127763	4.5%
t	111764	3.9%
c	105626	3.7%
Other values (51)	552374	19.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2320283	81.4%
Uppercase Letter	398542	14.0%
Space Separator	74635	2.6%
Dash Punctuation	55633	2.0%
Decimal Number	1245	< 0.1%
Close Punctuation	67	< 0.1%
Open Punctuation	66	< 0.1%
Other Punctuation	19	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	445272	19.2%
a	384938	16.6%
n	378909	16.3%
e	208370	9.0%
v	169376	7.3%
i	152015	6.6%
o	127763	5.5%
t	111764	4.8%
c	105626	4.6%
p	101047	4.4%
Other values (13)	135203	5.8%

Uppercase Letter

Value	Count	Frequency (%)
C	214083	53.7%
I	55013	13.8%
R	53042	13.3%
L	48211	12.1%
F	10926	2.7%
S	9884	2.5%
N	3062	0.8%
T	1585	0.4%
P	1296	0.3%
O	441	0.1%
Other values (13)	999	0.3%

Decimal Number

Value	Count	Frequency (%)
4	359	28.8%
1	313	25.1%
7	306	24.6%
5	255	20.5%
8	5	0.4%
0	5	0.4%
6	1	0.1%
3	1	0.1%

Other Punctuation

Value	Count	Frequency (%)
/	15	78.9%
.	3	15.8%
'	1	5.3%

Space Separator

Value	Count	Frequency (%)
	74635	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	55633	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	67	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	66	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2718825	95.4%
Common	131665	4.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	445272	16.4%
a	384938	14.2%
n	378909	13.9%
C	214083	7.9%
e	208370	7.7%
v	169376	6.2%
i	152015	5.6%
o	127763	4.7%
t	111764	4.1%
c	105626	3.9%
Other values (36)	420709	15.5%

Common

Value	Count	Frequency (%)
	74635	56.7%
-	55633	42.3%
4	359	0.3%
1	313	0.2%
7	306	0.2%
5	255	0.2%
)	67	0.1%
(	66	0.1%
/	15	< 0.1%
8	5	< 0.1%
Other values (5)	11	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2850490	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	445272	15.6%
a	384938	13.5%
n	378909	13.3%
C	214083	7.5%
e	208370	7.3%
v	169376	5.9%
i	152015	5.3%
o	127763	4.5%
t	111764	3.9%
c	105626	3.7%
Other values (51)	552374	19.4%

Results
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

Pass	137862
Fail	52312
Pass w/ Conditions	40768
Out of Business	22623
No Entry	10699
Other values (2)	3487

Length

Max length	20
Median length	4
Mean length	7.2895563
Min length	4

Characters and Unicode

Total characters	1951786
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pass
2nd row	Pass
3rd row	Pass
4th row	Fail
5th row	Pass

Common Values

Value	Count	Frequency (%)
Pass	137862	51.5%
Fail	52312	19.5%
Pass w/ Conditions	40768	15.2%
Out of Business	22623	8.4%
No Entry	10699	4.0%
Not Ready	3401	1.3%
Business Not Located	86	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pass	178630	43.7%
fail	52312	12.8%
w	40768	10.0%
conditions	40768	10.0%
business	22709	5.6%
out	22623	5.5%
of	22623	5.5%
no	10699	2.6%
entry	10699	2.6%
not	3487	0.9%
Other values (2)	3487	0.9%

Most occurring characters

Value	Count	Frequency (%)
s	466155	23.9%
a	234429	12.0%
P	178630	9.2%
i	156557	8.0%
	141054	7.2%
o	118431	6.1%
n	114944	5.9%
t	77663	4.0%
l	52312	2.7%
F	52312	2.7%
Other values (16)	359299	18.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1424550	73.0%
Uppercase Letter	345414	17.7%
Space Separator	141054	7.2%
Other Punctuation	40768	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	466155	32.7%
a	234429	16.5%
i	156557	11.0%
o	118431	8.3%
n	114944	8.1%
t	77663	5.5%
l	52312	3.7%
u	45332	3.2%
d	44255	3.1%
w	40768	2.9%
Other values (5)	73704	5.2%

Uppercase Letter

Value	Count	Frequency (%)
P	178630	51.7%
F	52312	15.1%
C	40768	11.8%
B	22709	6.6%
O	22623	6.5%
N	14186	4.1%
E	10699	3.1%
R	3401	1.0%
L	86	< 0.1%

Space Separator

Value	Count	Frequency (%)
	141054	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	40768	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1769964	90.7%
Common	181822	9.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	466155	26.3%
a	234429	13.2%
P	178630	10.1%
i	156557	8.8%
o	118431	6.7%
n	114944	6.5%
t	77663	4.4%
l	52312	3.0%
F	52312	3.0%
u	45332	2.6%
Other values (14)	273199	15.4%

Common

Value	Count	Frequency (%)
	141054	77.6%
/	40768	22.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1951786	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	466155	23.9%
a	234429	12.0%
P	178630	9.2%
i	156557	8.0%
	141054	7.2%
o	118431	6.1%
n	114944	5.9%
t	77663	4.0%
l	52312	2.7%
F	52312	2.7%
Other values (16)	359299	18.4%

Violations
Text

MISSING

Distinct	193077
Distinct (%)	99.3%
Missing	73407
Missing (%)	27.4%
Memory size	2.0 MiB

Length

Max length	11620
Median length	5021
Mean length	1221.1646
Min length	30

Characters and Unicode

Total characters	237326004
Distinct characters	100
Distinct categories	14 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	192163 ?
Unique (%)	98.9%

Sample

1st row	58. ALLERGEN TRAINING AS REQUIRED - Comments: 2-102.13 OBSERVED THE CITY OF CHICAGO FOOD SERVICE SANITATION MANAGER WITHOUT ALLERGEN TRAINING. INSTRUCTED TO MEET REQUIREMENT.
2nd row	53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: INSTRUCTED MANAGER TO PROVIDE AND MAINTAIN SMALL GARBAGE CAN WITH LID IN THE UNISEX WASHROOMS AS REQUIRED. \| 56. ADEQUATE VENTILATION & LIGHTING; DESIGNATED AREAS USED - Comments: OBSERVED THE FILTERS ABOVE THE FLAT TOP GRILL DIRTY. MUST CLEAN AND MAINTAIN.
3rd row	1. PERSON IN CHARGE PRESENT, DEMONSTRATES KNOWLEDGE, AND PERFORMS DUTIES - Comments: OBSERVED NO CITY OF CHICAGO CERTIFIED FOOD MANAGER ON SITE DURING THE TIME OF INSPECTION \| 2. CITY OF CHICAGO FOOD SERVICE SANITATION CERTIFICATE - Comments: OBSERVED NO CITY OF CHICAGO CERTIFIED FOOD MANAGER ON SITE DURING THE TIME OF INSPECTION WHILE PREPARING AND SERVING TCS FOODS (GYROS, CHICKEN, ITALIAN BEEF, SLICED TOMATO, NACHO CHEESE). INSTRUCTED TO PROVIDE AT LEAST ONE ON-SITE WHILE OPEN AND OPERATING. MUST MAINTAIN. #7-38-012. CITATION ISSUED. \| 10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED NO HAND CLEANSER AVAILABLE AT HANDSINK LOCATED IN (IN USE) FRONT PREP, REAR PREP OR UNISEX TOILET ROOM. INSTRUCTED TO PROVIDE AND MAINTAIN PROPER HANDWASHING. PRIORITY FOUNDATION VIOLATION. #7-38-030 (c). CITATION. \| 10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED REAR HANDSINK BASIN FILLED WITH POTS, SOILED UTENSILS, SCRUBBING PADS AND SOILED TOWELS. INSTRUCTED TO REMOVE ALL SAID ITEMS AND USE HANDSHINK FOR HANDWASHING PURPOSES ONLY. PRIORITY FOUNDATION VIOLATION. #7-38-030 (c). CITATION ISSUED. \| 36. THERMOMETERS PROVIDED & ACCURATE - Comments: MISSING THERMOMETERS IN ALL COOLING UNITS ON THE PREMISES. INSTRUCTED TO PROVIDE AND MAINTAIN. \| 38. INSECTS, RODENTS, & ANIMALS NOT PRESENT - Comments: OBSERVED EVIDENCE OF PEST ACTIVITY ON SITE... NOTED APPROXIMATELY 12 SMALL BLACK LIVE FLIES FLING THROUGHOUT FRONT AND REAR PREP AREAS AND ON EXTERIOR EQUIPMENT SURFACES. APPROXIMATELY 100 SMALL RODENT DROPPINGS ON THE PREMISES IN THE FOLLOWING AREAS... FRONT PREP AREA SCATTERED ON FLOOR NEXT TO BREADING STATION AND UNDERNEATH 2 DOOR COOLING UNIT, UNDERNEATH ALL FRYERS AND ALONGSIDE WINDOWSILL FRONT PREP, REAR PREP/DISHWASHING AREA UNDERNEATH 3 COMPARTMENT SINK, REAR STORAGE UNDER SHELVING UNITS, ALONG BOTH SIDES MOP SINK. INSTRUCTED TO REMOVE DROPPINGS, SANITIZE AFFECTED AREAS, AND CONTACT PEST CONTROL FOR SERVICE. MUST ELIMINATE PEST ACTIVITY ON SITE. PRIORITY FOUNDATION VIOLATION. 7-38-020 (A). CITATION ISSUED. \| 48. WAREWASHING FACILITIES: INSTALLED, MAINTAINED & USED; TEST STRIPS - Comments: OBSERVED NO CHEMICAL TEST STRIPS ON SITE DURING THE TIME OF INSPECTION FOR TESTING SANITIZING SOLUTION STRENGTH AT THE 3-COMPARTMENT SINK. INSTRUCTED TO PROVIDE. PRIORITY FOUNDATION VIOLATION. #7-38-005. CITATION ISSUED. \| 49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: OBSERVED ALL HEAVY EQUIPMENT ON THE PREMISES WITH EXCESSIVE AMOUNTS OF DRIED FOOD DEBRIS AND FOOD SPLATTER ON INTERIOR AND EXTERIOR SURFACES. INSTRUCTED TO CLEAN AND MAINTAIN FREE OF ACCUMULATED FOOD RESIDUE. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED NO COVERED RECEPTACLE IN UNISEX TOILET ROOM. INSTRUCTED TO PROVIDE. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED ALL PLUMBING FIXTURES IN TOILET ROOM IN NEED OF CLEANING.INSTRUCTED TO PROVIDE AND MAINTAIN. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED EXCESSIVE TRASH, FOOD DEBRIS, FLOUR AND GREASE DEBRIS ON FLOORS THROUGHOUT FRONT PREP AREA UNDER ALL HEAVY EQUIPMENT. ALSO NOTED POOLED BLOOD AND CHICKEN PIECES ON WALK IN COOLER FLOORS. INSTRUCTED TO REMOVE, CLEAN AND MAINTAIN. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED CRUMBLING(RED) WALL IN FRONT PREP AREA NEAR WINDOW WHERE CHICKEN/FISH BREADING TAKES PLACE, LARGE HOLE AS WELL AS TORN WALL BASE ON WALL ACROSS FROM WHITE CHESTER FREEZER IN REAR PREP AREA. INSTRUCTED TO REPAIR SAID WALLS TO BE SMOOTH AND EASILY CLEANABLE. \| 56. ADEQUATE VENTILATION & LIGHTING; DESIGNATED AREAS USED - Comments: OBSERVED EXCESSIVE BUILD UP OF GREASE ON FILTERS IN HOOD VENTILATION SYSTEM OVER DEEP FRYERS. INSTRUCTED PERSON IN CHARGE TO CLEAN AND MAINTAIN. \| 57. ALL FOOD EMPLOYEES HAVE FOOD HANDLER TRAINING - Comments: OBSERVED NO FOOD HANDLER CERTIFICATES ON SITE FOR REVIEW. INSTRUCTED TO PROVIDE. \| 58. ALLERGEN TRAINING AS REQUIRED - Comments: NO ALLERGEN TRAINING CERTIFCATE ON SITE FOR REVIEW. INSTRUCTED TO OBATIN AS REQUIRED.
4th row	59. PREVIOUS PRIORITY FOUNDATION VIOLATION CORRECTED - Comments: OBSERVED PREVIOUS PRIORITY FOUNDATION VIOLATION NOT CORRECTED WITHIN SPECIFIED TIMEFRAME. REPORT #2589292 DATED FEBRUARY 7 2024 INSTRUCTED FACILITY TO ADDRESS PREVIOUS CORE VIOLATION OF NO GREASE TRAP AT BASEMENT 3 COMPARTMENT SINK. OBSERVED NO GREASE TRAP AT BASEMENT 3 COMPARTMENT SINK. INSTRUCTED MANAGER TO ADDRESS PREVIOUS PRIORITY FOUNDATION VIOLATION. PRIORITY VIOLATION 7-42-090 NO CITATION ISSUED.
5th row	49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: OBSERVED RESIDUE ON THE BOTTOM OF TWO-DOOR REACH-IN COOLER. INSTRUCTED PERSON IN CHARGE TO CLEAN AND MAINTAIN.

Value	Count	Frequency (%)
	1838865	5.1%
and	1679218	4.7%
comments	899940	2.5%
the	828939	2.3%
in	754935	2.1%
to	705750	2.0%
of	647905	1.8%
food	630359	1.8%
clean	566094	1.6%
must	409835	1.1%
Other values (196558)	26780291	74.9%

Most occurring characters

Value	Count	Frequency (%)
	36337975	15.3%
E	19599115	8.3%
N	13660291	5.8%
O	13579436	5.7%
A	13202316	5.6%
T	12856190	5.4%
I	12549640	5.3%
R	11578300	4.9%
S	10536595	4.4%
D	9241482	3.9%
Other values (90)	84184664	35.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	163518414	68.9%
Space Separator	36337975	15.3%
Lowercase Letter	23287895	9.8%
Other Punctuation	6965398	2.9%
Decimal Number	4168111	1.8%
Dash Punctuation	1975917	0.8%
Math Symbol	685040	0.3%
Open Punctuation	185468	0.1%
Close Punctuation	183297	0.1%
Currency Symbol	13998	< 0.1%
Other values (4)	4491	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2949530	12.7%
n	2314068	9.9%
o	2297146	9.9%
t	2165291	9.3%
m	2091395	9.0%
s	2030018	8.7%
a	1526221	6.6%
l	1154964	5.0%
i	1135675	4.9%
r	986289	4.2%
Other values (17)	4637298	19.9%

Uppercase Letter

Value	Count	Frequency (%)
E	19599115	12.0%
N	13660291	8.4%
O	13579436	8.3%
A	13202316	8.1%
T	12856190	7.9%
I	12549640	7.7%
R	11578300	7.1%
S	10536595	6.4%
D	9241482	5.7%
L	7659915	4.7%
Other values (16)	39055134	23.9%

Other Punctuation

Value	Count	Frequency (%)
.	2994820	43.0%
,	1878621	27.0%
:	1378975	19.8%
&	232853	3.3%
/	232107	3.3%
;	116249	1.7%
#	59962	0.9%
'	52109	0.7%
*	15485	0.2%
@	2723	< 0.1%
Other values (5)	1494	< 0.1%

Decimal Number

Value	Count	Frequency (%)
3	890360	21.4%
0	614039	14.7%
5	506794	12.2%
1	498646	12.0%
4	397477	9.5%
2	395999	9.5%
8	310055	7.4%
7	280923	6.7%
6	167783	4.0%
9	106035	2.5%

Math Symbol

Value	Count	Frequency (%)
\|	684645	99.9%
=	292	< 0.1%
+	76	< 0.1%
>	18	< 0.1%
~	5	< 0.1%
<	4	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	185213	99.9%
[	243	0.1%
{	12	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	183095	99.9%
]	190	0.1%
}	12	< 0.1%

Control

Value	Count	Frequency (%)
	3920	99.9%
	2	0.1%
	1	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
`	13	81.2%
^	3	18.8%

Space Separator

Value	Count	Frequency (%)
	36337975	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1975917	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	13998	100.0%

Other Number

Value	Count	Frequency (%)
½	483	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	69	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	186806309	78.7%
Common	50519695	21.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	19599115	10.5%
N	13660291	7.3%
O	13579436	7.3%
A	13202316	7.1%
T	12856190	6.9%
I	12549640	6.7%
R	11578300	6.2%
S	10536595	5.6%
D	9241482	4.9%
L	7659915	4.1%
Other values (43)	62343029	33.4%

Common

Value	Count	Frequency (%)
	36337975	71.9%
.	2994820	5.9%
-	1975917	3.9%
,	1878621	3.7%
:	1378975	2.7%
3	890360	1.8%
\|	684645	1.4%
0	614039	1.2%
5	506794	1.0%
1	498646	1.0%
Other values (37)	2758903	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	237324555	> 99.9%
None	1449	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	36337975	15.3%
E	19599115	8.3%
N	13660291	5.8%
O	13579436	5.7%
A	13202316	5.6%
T	12856190	5.4%
I	12549640	5.3%
R	11578300	4.9%
S	10536595	4.4%
D	9241482	3.9%
Other values (87)	84183215	35.5%

None

Value	Count	Frequency (%)
ï	483	33.3%
½	483	33.3%
¿	483	33.3%

Latitude
Real number (ℝ)

Distinct	18215
Distinct (%)	6.8%
Missing	925
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	41.880696

Minimum	41.64467
Maximum	42.021064
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.0 MiB

Quantile statistics

Minimum	41.64467
5-th percentile	41.726853
Q1	41.83164
median	41.891736
Q3	41.93978
95-th percentile	41.997516
Maximum	42.021064
Range	0.37639412
Interquartile range (IQR)	0.10814014

Descriptive statistics

Standard deviation	0.081083501
Coefficient of variation (CV)	0.0019360591
Kurtosis	-0.35567981
Mean	41.880696
Median Absolute Deviation (MAD)	0.050642108
Skewness	-0.58917919
Sum	11174859
Variance	0.0065745342
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42.00875077	3291	1.2%
41.78932932	768	0.3%
41.88418751	597	0.2%
41.88199434	586	0.2%
41.85045102	584	0.2%
41.88743405	480	0.2%
41.88458627	377	0.1%
41.88807428	369	0.1%
41.89209414	368	0.1%
41.75466012	342	0.1%
Other values (18205)	259064	96.8%
(Missing)	925	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.64467013	13	< 0.1%
41.64566748	4	< 0.1%
41.64637082	7	< 0.1%
41.64655405	2	< 0.1%
41.64818878	9	< 0.1%
41.64863829	6	< 0.1%
41.64868838	3	< 0.1%
41.64874251	2	< 0.1%
41.64881845	3	< 0.1%
41.64936399	17	< 0.1%

Value	Count	Frequency (%)
42.02106425	25	< 0.1%
42.02086075	16	< 0.1%
42.02080848	16	< 0.1%
42.02075289	7	< 0.1%
42.02039924	1	< 0.1%
42.02008731	15	< 0.1%
42.01986688	21	< 0.1%
42.01958216	20	< 0.1%
42.019494	5	< 0.1%
42.0194929	1	< 0.1%

Longitude
Real number (ℝ)

Distinct	18215
Distinct (%)	6.8%
Missing	925
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	-87.676329

Minimum	-87.906874
Maximum	-87.525094
Zeros	0
Zeros (%)	0.0%
Negative	266826
Negative (%)	99.7%
Memory size	2.0 MiB

Quantile statistics

Minimum	-87.906874
5-th percentile	-87.777776
Q1	-87.707517
median	-87.666419
Q3	-87.634942
95-th percentile	-87.599527
Maximum	-87.525094
Range	0.38178
Interquartile range (IQR)	0.072575797

Descriptive statistics

Standard deviation	0.058266449
Coefficient of variation (CV)	-0.00066456305
Kurtosis	2.0957592
Mean	-87.676329
Median Absolute Deviation (MAD)	0.034451661
Skewness	-0.97546595
Sum	-23394324
Variance	0.003394979
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.90687413	3291	1.2%
-87.74164564	768	0.3%
-87.64111967	597	0.2%
-87.63975868	586	0.2%
-87.65879786	584	0.2%
-87.68184949	480	0.2%
-87.63101045	377	0.1%
-87.6349552	369	0.1%
-87.61156988	368	0.1%
-87.74138476	342	0.1%
Other values (18205)	259064	96.8%
(Missing)	925	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.90687413	3291	1.2%
-87.90675786	3	< 0.1%
-87.90530913	12	< 0.1%
-87.88270766	2	< 0.1%
-87.86695767	1	< 0.1%
-87.86302998	25	< 0.1%
-87.86237264	9	< 0.1%
-87.84631989	11	< 0.1%
-87.84631558	2	< 0.1%
-87.8463105	1	< 0.1%

Value	Count	Frequency (%)
-87.52509414	12	< 0.1%
-87.52512485	17	< 0.1%
-87.52571243	4	< 0.1%
-87.5258717	19	< 0.1%
-87.5261364	9	< 0.1%
-87.52664793	20	< 0.1%
-87.52667081	11	< 0.1%
-87.52694018	16	< 0.1%
-87.52749847	2	< 0.1%
-87.52770401	3	< 0.1%

Location
Text

Distinct	18215
Distinct (%)	6.8%
Missing	925
Missing (%)	0.3%
Memory size	2.0 MiB

Length

Max length	40
Median length	39
Mean length	39.059649
Min length	34

Characters and Unicode

Total characters	10422130
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1595 ?
Unique (%)	0.6%

Sample

1st row	(41.84560861006466, -87.69538780161594)
2nd row	(41.799368015121125, -87.59468625684886)
3rd row	(41.894208809612294, -87.66738222845791)
4th row	(41.86629065519555, -87.72456177467829)
5th row	(41.7710280071688, -87.58641718666685)

Value	Count	Frequency (%)
42.00875076599798	3291	0.6%
87.90687413400109	3291	0.6%
41.789329323265385	768	0.1%
87.74164564419637	768	0.1%
41.884187507127805	597	0.1%
87.64111966683218	597	0.1%
41.88199433820508	586	0.1%
87.6397586848809	586	0.1%
41.85045102427	584	0.1%
87.65879785567869	584	0.1%
Other values (36420)	522000	97.8%

Most occurring characters

Value	Count	Frequency (%)
8	1079368	10.4%
7	1072631	10.3%
4	989479	9.5%
1	924788	8.9%
6	906312	8.7%
9	809228	7.8%
5	730762	7.0%
2	703163	6.7%
3	688983	6.6%
0	649634	6.2%
Other values (6)	1867782	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8554348	82.1%
Other Punctuation	800478	7.7%
Open Punctuation	266826	2.6%
Space Separator	266826	2.6%
Dash Punctuation	266826	2.6%
Close Punctuation	266826	2.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	1079368	12.6%
7	1072631	12.5%
4	989479	11.6%
1	924788	10.8%
6	906312	10.6%
9	809228	9.5%
5	730762	8.5%
2	703163	8.2%
3	688983	8.1%
0	649634	7.6%

Other Punctuation

Value	Count	Frequency (%)
.	533652	66.7%
,	266826	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	266826	100.0%

Space Separator

Value	Count	Frequency (%)
	266826	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	266826	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	266826	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10422130	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	1079368	10.4%
7	1072631	10.3%
4	989479	9.5%
1	924788	8.9%
6	906312	8.7%
9	809228	7.8%
5	730762	7.0%
2	703163	6.7%
3	688983	6.6%
0	649634	6.2%
Other values (6)	1867782	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10422130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	1079368	10.4%
7	1072631	10.3%
4	989479	9.5%
1	924788	8.9%
6	906312	8.7%
9	809228	7.8%
5	730762	7.0%
2	703163	6.7%
3	688983	6.6%
0	649634	6.2%
Other values (6)	1867782	17.9%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Inspection ID	DBA Name	AKA Name	License #	Facility Type	Risk	Address	City	State	Zip	Inspection Date	Inspection Type	Results	Violations	Latitude	Longitude	Location
0	2589679	HOLY SMOQUES BBQ	HOLY SMOQUES BBQ	2948383.0	Restaurant	Risk 1 (High)	2524 S CALIFORNIA AVE	CHICAGO	IL	60608.0	02/15/2024	License Re-Inspection	Pass	58. ALLERGEN TRAINING AS REQUIRED - Comments: 2-102.13 OBSERVED THE CITY OF CHICAGO FOOD SERVICE SANITATION MANAGER WITHOUT ALLERGEN TRAINING. INSTRUCTED TO MEET REQUIREMENT.	41.845609	-87.695388	(41.84560861006466, -87.69538780161594)
1	2589673	SMALL CHEVAL	SMALL CHEVAL	2830796.0	Restaurant	Risk 1 (High)	1307-1309 E 53RD ST	CHICAGO	IL	60615.0	02/15/2024	Canvass	Pass	53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: INSTRUCTED MANAGER TO PROVIDE AND MAINTAIN SMALL GARBAGE CAN WITH LID IN THE UNISEX WASHROOMS AS REQUIRED. \| 56. ADEQUATE VENTILATION & LIGHTING; DESIGNATED AREAS USED - Comments: OBSERVED THE FILTERS ABOVE THE FLAT TOP GRILL DIRTY. MUST CLEAN AND MAINTAIN.	41.799368	-87.594686	(41.799368015121125, -87.59468625684886)
2	2589681	BARTOLI'S PIZZERIA	BARTOLI'S PIZZERIA	2709388.0	Restaurant	Risk 1 (High)	658 N ASHLAND AVE	CHICAGO	IL	60622.0	02/15/2024	Canvass Re-Inspection	Pass	NaN	41.894209	-87.667382	(41.894208809612294, -87.66738222845791)
3	2589674	SEASHELL	SEASHELL	2551804.0	Restaurant	Risk 2 (Medium)	3944 W ROOSEVELT RD	CHICAGO	IL	60624.0	02/15/2024	Complaint	Fail	1. PERSON IN CHARGE PRESENT, DEMONSTRATES KNOWLEDGE, AND PERFORMS DUTIES - Comments: OBSERVED NO CITY OF CHICAGO CERTIFIED FOOD MANAGER ON SITE DURING THE TIME OF INSPECTION \| 2. CITY OF CHICAGO FOOD SERVICE SANITATION CERTIFICATE - Comments: OBSERVED NO CITY OF CHICAGO CERTIFIED FOOD MANAGER ON SITE DURING THE TIME OF INSPECTION WHILE PREPARING AND SERVING TCS FOODS (GYROS, CHICKEN, ITALIAN BEEF, SLICED TOMATO, NACHO CHEESE). INSTRUCTED TO PROVIDE AT LEAST ONE ON-SITE WHILE OPEN AND OPERATING. MUST MAINTAIN. #7-38-012. CITATION ISSUED. \| 10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED NO HAND CLEANSER AVAILABLE AT HANDSINK LOCATED IN (IN USE) FRONT PREP, REAR PREP OR UNISEX TOILET ROOM. INSTRUCTED TO PROVIDE AND MAINTAIN PROPER HANDWASHING. PRIORITY FOUNDATION VIOLATION. #7-38-030 (c). CITATION. \| 10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED REAR HANDSINK BASIN FILLED WITH POTS, SOILED UTENSILS, SCRUBBING PADS AND SOILED TOWELS. INSTRUCTED TO REMOVE ALL SAID ITEMS AND USE HANDSHINK FOR HANDWASHING PURPOSES ONLY. PRIORITY FOUNDATION VIOLATION. #7-38-030 (c). CITATION ISSUED. \| 36. THERMOMETERS PROVIDED & ACCURATE - Comments: MISSING THERMOMETERS IN ALL COOLING UNITS ON THE PREMISES. INSTRUCTED TO PROVIDE AND MAINTAIN. \| 38. INSECTS, RODENTS, & ANIMALS NOT PRESENT - Comments: OBSERVED EVIDENCE OF PEST ACTIVITY ON SITE... NOTED APPROXIMATELY 12 SMALL BLACK LIVE FLIES FLING THROUGHOUT FRONT AND REAR PREP AREAS AND ON EXTERIOR EQUIPMENT SURFACES. APPROXIMATELY 100 SMALL RODENT DROPPINGS ON THE PREMISES IN THE FOLLOWING AREAS... FRONT PREP AREA SCATTERED ON FLOOR NEXT TO BREADING STATION AND UNDERNEATH 2 DOOR COOLING UNIT, UNDERNEATH ALL FRYERS AND ALONGSIDE WINDOWSILL FRONT PREP, REAR PREP/DISHWASHING AREA UNDERNEATH 3 COMPARTMENT SINK, REAR STORAGE UNDER SHELVING UNITS, ALONG BOTH SIDES MOP SINK. INSTRUCTED TO REMOVE DROPPINGS, SANITIZE AFFECTED AREAS, AND CONTACT PEST CONTROL FOR SERVICE. MUST ELIMINATE PEST ACTIVITY ON SITE. PRIORITY FOUNDATION VIOLATION. 7-38-020 (A). CITATION ISSUED. \| 48. WAREWASHING FACILITIES: INSTALLED, MAINTAINED & USED; TEST STRIPS - Comments: OBSERVED NO CHEMICAL TEST STRIPS ON SITE DURING THE TIME OF INSPECTION FOR TESTING SANITIZING SOLUTION STRENGTH AT THE 3-COMPARTMENT SINK. INSTRUCTED TO PROVIDE. PRIORITY FOUNDATION VIOLATION. #7-38-005. CITATION ISSUED. \| 49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: OBSERVED ALL HEAVY EQUIPMENT ON THE PREMISES WITH EXCESSIVE AMOUNTS OF DRIED FOOD DEBRIS AND FOOD SPLATTER ON INTERIOR AND EXTERIOR SURFACES. INSTRUCTED TO CLEAN AND MAINTAIN FREE OF ACCUMULATED FOOD RESIDUE. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED NO COVERED RECEPTACLE IN UNISEX TOILET ROOM. INSTRUCTED TO PROVIDE. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED ALL PLUMBING FIXTURES IN TOILET ROOM IN NEED OF CLEANING.INSTRUCTED TO PROVIDE AND MAINTAIN. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED EXCESSIVE TRASH, FOOD DEBRIS, FLOUR AND GREASE DEBRIS ON FLOORS THROUGHOUT FRONT PREP AREA UNDER ALL HEAVY EQUIPMENT. ALSO NOTED POOLED BLOOD AND CHICKEN PIECES ON WALK IN COOLER FLOORS. INSTRUCTED TO REMOVE, CLEAN AND MAINTAIN. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED CRUMBLING(RED) WALL IN FRONT PREP AREA NEAR WINDOW WHERE CHICKEN/FISH BREADING TAKES PLACE, LARGE HOLE AS WELL AS TORN WALL BASE ON WALL ACROSS FROM WHITE CHESTER FREEZER IN REAR PREP AREA. INSTRUCTED TO REPAIR SAID WALLS TO BE SMOOTH AND EASILY CLEANABLE. \| 56. ADEQUATE VENTILATION & LIGHTING; DESIGNATED AREAS USED - Comments: OBSERVED EXCESSIVE BUILD UP OF GREASE ON FILTERS IN HOOD VENTILATION SYSTEM OVER DEEP FRYERS. INSTRUCTED PERSON IN CHARGE TO CLEAN AND MAINTAIN. \| 57. ALL FOOD EMPLOYEES HAVE FOOD HANDLER TRAINING - Comments: OBSERVED NO FOOD HANDLER CERTIFICATES ON SITE FOR REVIEW. INSTRUCTED TO PROVIDE. \| 58. ALLERGEN TRAINING AS REQUIRED - Comments: NO ALLERGEN TRAINING CERTIFCATE ON SITE FOR REVIEW. INSTRUCTED TO OBATIN AS REQUIRED.	41.866291	-87.724562	(41.86629065519555, -87.72456177467829)
4	2589661	J & J FISH & CHICKEN	J & J FISH & CHICKEN	1938693.0	Restaurant	Risk 1 (High)	6814 S STONY ISLAND AVE	CHICAGO	IL	60649.0	02/15/2024	Canvass Re-Inspection	Pass	NaN	41.771028	-87.586417	(41.7710280071688, -87.58641718666685)
5	2589645	NOORI CHICKEN CHICAGO	NOORI CHICKEN CHICAGO	2952358.0	NaN	All	3223 N CLARK ST	CHICAGO	IL	60657.0	02/15/2024	License	Not Ready	NaN	41.940634	-87.651057	(41.940634346439296, -87.65105735655327)
6	2589643	CURRY ON FIRE	CURRY ON FIRE	2535924.0	Restaurant	Risk 1 (High)	1030 W TAYLOR ST	CHICAGO	IL	60607.0	02/15/2024	Complaint	No Entry	NaN	41.869597	-87.652349	(41.86959706650426, -87.6523490175014)
7	2589633	Clemente Comm (H/S)	Clemente Comm (H/S)	51091.0	School	Risk 1 (High)	1147 N Western AVE	CHICAGO	IL	60622.0	02/15/2024	Canvass Re-Inspection	Fail	59. PREVIOUS PRIORITY FOUNDATION VIOLATION CORRECTED - Comments: OBSERVED PREVIOUS PRIORITY FOUNDATION VIOLATION NOT CORRECTED WITHIN SPECIFIED TIMEFRAME. REPORT #2589292 DATED FEBRUARY 7 2024 INSTRUCTED FACILITY TO ADDRESS PREVIOUS CORE VIOLATION OF NO GREASE TRAP AT BASEMENT 3 COMPARTMENT SINK. OBSERVED NO GREASE TRAP AT BASEMENT 3 COMPARTMENT SINK. INSTRUCTED MANAGER TO ADDRESS PREVIOUS PRIORITY FOUNDATION VIOLATION. PRIORITY VIOLATION 7-42-090 NO CITATION ISSUED.	41.902623	-87.686869	(41.90262318255785, -87.68686934199641)
8	2589639	CHIPOTLE MEXICAN GRILL #3651	CHIPOTLE	2748958.0	Restaurant	Risk 1 (High)	5533 S HARLEM AVE	CHICAGO	IL	60638.0	02/15/2024	Canvass	Pass	49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: OBSERVED RESIDUE ON THE BOTTOM OF TWO-DOOR REACH-IN COOLER. INSTRUCTED PERSON IN CHARGE TO CLEAN AND MAINTAIN.	41.790889	-87.801336	(41.790889200425, -87.80133630631802)
9	2589628	BENITO JUAREZ COMMUNITY ACADEMY	JUAREZ (H/S)	2915819.0	School	Risk 1 (High)	1450-1510 W CERMAK RD	CHICAGO	IL	60608.0	02/15/2024	Canvass	Pass	55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: 6-501.12 OBSERVED ACCUMULATED DUST DEBRIS ON THE CONDENSER OF THE WALK IN COOLER LOCATED NEXT TO THE HAND WASHING SINK IN THE FOOD PREP AREA AND UNDER THE 3 COMPARTMENT SINK BEHIND THE GREASE TRAP. INSTRUCTED TO CLEAN.	41.852496	-87.663190	(41.852495902869336, -87.66319041556977)

	Inspection ID	DBA Name	AKA Name	License #	Facility Type	Risk	Address	City	State	Zip	Inspection Date	Inspection Type	Results	Violations	Latitude	Longitude	Location
267741	158288	GREAT HUNNAN RESTAURANT	GREAT HUNNAN RESTAURANT	1193152.0	Restaurant	Risk 1 (High)	1958 W 35TH ST	CHICAGO	IL	60609.0	01/28/2010	Out of Business	Fail	NaN	41.830500	-87.675221	(41.83050041795062, -87.67522140471041)
267742	80220	THAI OSCAR INC.	THAI OSCAR INC.	1873390.0	Restaurant	Risk 1 (High)	4638 N WESTERN AVE	CHICAGO	IL	60625.0	01/15/2010	Complaint	Fail	18. NO EVIDENCE OF RODENT OR INSECT OUTER OPENINGS PROTECTED/RODENT PROOFED, A WRITTEN LOG SHALL BE MAINTAINED AVAILABLE TO THE INSPECTORS - Comments: All necessary control measures shall be used to effectively minimize or eliminate the presence of rodents, roaches, and other vermin and insects on the premises of all food establishments, in food-transporting vehicles, and in vending machines.//FRONT DOOR NOT RODENT & INSECT PROOF DOOR MEASURED AT 1/4' AT BOTTOM OF DOOR CORNER /LIVE ROCHER IN WOMEN RESTROOM \| 30. FOOD IN ORIGINAL CONTAINER, PROPERLY LABELED: CUSTOMER ADVISORY POSTED AS NEEDED - Comments: All food not stored in the original container shall be stored in properly labeled containers.//NAMES DATES TIME OF PREPERATION OF FOOD ON CONTAINER \| 31. CLEAN MULTI-USE UTENSILS AND SINGLE SERVICE ARTICLES PROPERLY STORED: NO REUSE OF SINGLE SERVICE ARTICLES - Comments: Containers and utensils shall be inverted, covered, or otherwise protected from contamination until used. All single-service drinking straws and containers shall be discarded immediately after use.//INVERT ALL POTS & PANS IN KITCHEN AREA \| 32. FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: All food and non-food contact equipment and utensils shall be smooth, easily cleanable, and durable, and shall be in good repair.//REPLACE ALL STAIN & BADLY PITTED CUTTING BOARD IN PREP AREA \| 33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: All food and non-food contact surfaces of equipment and all food storage utensils shall be thoroughly cleaned and sanitized daily.//SOME SHELVES IN COOLERS ,DRY STORAGE ,UNDER HOOD OVER COOKINGRANGE NEED DETAIL CLEANING \| 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: The floors shall be constructed per code, be smooth and easily cleaned, and be kept clean and in good repair.//FLOORS UNDER AROUND STOCK &EQUIPMENT NEED DETAIL CLEANING \| 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: The walls and ceilings shall be in good repair and easily cleaned.//REPLACE ALL STAIN & POOR REPAIR CEILING TILE IN RESTROOMS MEN & WOMEN RESTROOM/DOOR TO KITCHEN AREA POOR REPAIR \| 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: The flow of air discharged from kitchen fans shall always be through a duct to a point above the roofline.//MUST REPAIR VENTILATION FAN COVER IN MEN RESTROOM	41.965990	-87.688972	(41.965989980278934, -87.68897226767825)
267743	197242	SOPRAFFINA	SOPRAFFINA	35095.0	Restaurant	Risk 1 (High)	10 N DEARBORN ST	CHICAGO	IL	60602.0	02/01/2010	Canvass	Pass	32. FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: All food and non-food contact equipment and utensils shall be smooth, easily cleanable, and durable, and shall be in good repair. SALAD STATION PREP TABLE IN POOR REPAIR, BROKEN VENEER AT TOP SURFACE, INSTRUCTED TO REPAIR \| 40. REFRIGERATION AND METAL STEM THERMOMETERS PROVIDED AND CONSPICUOUS - Comments: All food establishments that display, prepare, or store potentially hazardous foods shall have calibrated metal stem thermometers, provided and conspicuous, for refrigerated and hot food units. MUST INSTALL A REFRIGERATION THERMOMETER IN THE WARMEST PART OF COOLER AND CONSPICUOUS.	41.882216	-87.629556	(41.88221569794795, -87.6295562535779)
267744	193209	APPLEBEE'S NEIGHBORHOOD GRILL & BAR	APPLEBEE'S NEIGHBORHOOD GRILL & BAR	1477462.0	Restaurant	Risk 1 (High)	7519 S CICERO AVE	CHICAGO	IL	60652.0	01/25/2010	Canvass Re-Inspection	Pass	NaN	41.755956	-87.741433	(41.75595600567047, -87.74143262060872)
267745	68128	DINER GRILL	DINER GRILL	57105.0	Restaurant	Risk 1 (High)	1635 W IRVING PARK RD	CHICAGO	IL	60613.0	02/03/2010	Canvass	Pass w/ Conditions	3. POTENTIALLY HAZARDOUS FOOD MEETS TEMPERATURE REQUIREMENT DURING STORAGE, PREPARATION DISPLAY AND SERVICE - Comments: All cold food shall be stored at a temperature of 40F or less. FOUND FRESH EGGS STORED UNDER FRONT COUNTER,AT IMPROPER TEMPERATURE 58.6F, AND 60F.FRESH EGGS MUST MAINTAIN TEMPERATURE OF 40F OR BELOW.(90 EACH EGGS), VALUE $5. CRITICAL VIOLATION:7-38-005(A) HOOOO60443-10 \| 12. HAND WASHING FACILITIES: WITH SOAP AND SANITARY HAND DRYING DEVICES, CONVENIENT AND ACCESSIBLE TO FOOD PREP AREA - Comments: Adequate and convenient hand washing facilities shall be provided for all employees. FOUND EXPOSED HAND SINKS NOT ACCESSIBLE, IN REAR PREP AREA(SINK WAS FULL OF CLEANING MATERIALS AND POT);FRONT EXPOSED HAND SINK NO SOAP OR PAPER TOWELS, ALSO HOT AND COLD WATER DOESN'T HAVE ENOUGH WATER FLOW.OBSERVED EMPLOYEE WASHING HAND AT 3 COMPARTMENT SINK. TAGGED'HELD FOR INSPECTION' FRONT EXPOSED HAND SINK , INSTRUCTED TO USE REAR EXPOSED HAND SINK ,WHICH ITEMS WAS REMOVED.CRITICAL VIOLATION:7-38-030 HOOOO60443-10. FAX A LETTER WHEN SINK IS FIXED.(FAX #312-746-4240) \| 32. FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: All food and non-food contact equipment and utensils shall be smooth, easily cleanable, and durable, and shall be in good repair.REPLACE BROKEN RUSTY RUBBER GASKET IN ICE CREAM CHEST FREZEER.REPLACE RUSTY BLADE FROM CAN OPENER. \| 33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: All food and non-food contact surfaces of equipment and all food storage utensils shall be thoroughly cleaned and sanitized daily.REMOVE BUILD UP ICE INSIDE THE ICE CREAM CHEST FREEZER. \| 36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES OF LIGHT PROVIDED, FIXTURES SHIELDED - Comments: Shielding to protect against broken glass falling into food shall be provided for all artificial lighting sources in preparation, service, and display facilities.LIGHT SHIELD IS NEEDED AT LIGHT IN FRONT PREP AREA \| 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: Ventilation: All plumbing fixtures, such as toilets, sinks, washbasins, etc., must be adequately trapped, vented, and re-vented and properly connected to the sewer in accordance with the plumbing chapter of the Municipal Code of Chicago and the Rules and Regulations of the Board of Health.FAUCET IN 3 COMPARTMENT SINK IS LEAKING, ALSO PIPE UNDER 3 COMPARTMENT SINKS. REPAIR LEAKING PIPE ON CEILING IN REAR PREP ARE AND FRONT STORAGE AREA.	41.954161	-87.670369	(41.954161252677814, -87.67036928186604)
267746	164285	BARNARD	BARNARD	22131.0	School	Risk 1 (High)	10354 S Charles (1432W)	CHICAGO	IL	60643.0	01/21/2010	Canvass	Pass	34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: The floors shall be constructed per code, be smooth and easily cleaned, and be kept clean and in good repair. FLOORS NEED CLEANING IN BOILER ROOM(STANDING WATER). REPAIR THRESHOLD UNDER BOILER ROOM DOOR. \| 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: The walls and ceilings shall be in good repair and easily cleaned. SEAL ALL CRACKS AND CREVICES ALONG WALLS AND BASEBOARDS IN KITCHEN AND TEACHERS LOUNGE NEAR SINK. WALLS NEED REPAIR IN KITCHEN, OFFICE/STORAGE AND HALLWAY AREAS BEHIND EQUIPMENT (PEELING PAINT) AND IN WOMEN AND MEN AUDITORIUM WASHROOMS. SEAL ALL OPENINGS AROUND PIPE FITTINGS BEHIND TOILETS AND UNDER SINKS IN ALL WASHROOMS. \| 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: Ventilation: All plumbing fixtures, such as toilets, sinks, washbasins, etc., must be adequately trapped, vented, and re-vented and properly connected to the sewer in accordance with the plumbing chapter of the Municipal Code of Chicago and the Rules and Regulations of the Board of Health. PROVIDE VENTILATION IN WOMEN'S AUDITORIUM WASHROOM. INCREASE PRESSURE ON ALL WATER FOUNTAINS. REPAIR ALL LEAKS IN BOILER ROOM.	41.705140	-87.658116	(41.70514023786158, -87.65811642455638)
267747	124314	Dany's Mini Mart	Danny's Mini Mart	2016778.0	Grocery Store	Risk 3 (Low)	3464 N Pulaski RD	CHICAGO	IL	60641.0	02/05/2010	License Re-Inspection	Pass	NaN	41.944569	-87.727492	(41.94456913331175, -87.72749197013754)
267748	98337	TAQUERIA EL RANCHITO	TAQUERIA EL RANCHITO	60184.0	Restaurant	Risk 1 (High)	2829 N MILWAUKEE AVE	CHICAGO	IL	60618.0	01/19/2010	Suspected Food Poisoning	Pass	33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: All food and non-food contact surfaces of equipment and all food storage utensils shall be thoroughly cleaned and sanitized daily.CLEAN INTERIOR FRONT CABINTS, BEER COOLER, DEFROST BOX FREEZER FRONT, COFFEE DRIP TRAY. CLEAN STOVE, OVEN. \| 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: CLEAN FLOOR THRU OUT REAR PREP, RESEAL BASEMENT FLOOR. \| 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: REPLACE CEILING TILES REAR PREP AREA. \| 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: SINK NOZZEL LEAKING AT FRONT BAR. INSTRUCTED TO REPAIR. \| 41. PREMISES MAINTAINED FREE OF LITTER, UNNECESSARY ARTICLES, CLEANING EQUIPMENT PROPERLY STORED - Comments: SOME CLUTTER IN BASEMENT INSTRUCTED TO REMOVE ITEMS NOT BEING USED.	41.932657	-87.713056	(41.93265693660558, -87.71305610116421)
267749	120283	EAST COAST PANTRY	EAST COAST PANTRY	1892217.0	Grocery Store	Risk 2 (Medium)	611 S WELLS ST	CHICAGO	IL	60607.0	01/11/2010	Canvass	Pass	40. REFRIGERATION AND METAL STEM THERMOMETERS PROVIDED AND CONSPICUOUS - Comments: All food establishments that display, prepare, or store potentially hazardous foods shall have calibrated metal stem thermometers, provided and conspicuous, for refrigerated and hot food units. Place a thermometer in the packaged deli case.	41.874243	-87.633477	(41.874242987183976, -87.63347653027343)
267750	124281	GAS CENTER	GAS CENTER	1958643.0	Grocery Store	Risk 3 (Low)	4409 N CENTRAL AVE	CHICAGO	IL	60630.0	01/20/2010	License Re-Inspection	Pass	NaN	41.960767	-87.767104	(41.96076719873542, -87.76710408243011)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Math Symbol

Connector Punctuation

Currency Symbol

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Open Punctuation

Close Punctuation

Space Separator

Dash Punctuation

Math Symbol

Connector Punctuation

Other Number

Modifier Symbol

Currency Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts